<div class="editor-default-node4-header-medium" data-template="t_4_3">
	<img src="https://urc-thumb.oss-cn-beijing.aliyuncs.com/resource-temp/1725514076938section-ico4.png">1.3.2 数据库配置文件
</div>
<p style="text-align:justify;">
	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;“postgresql.conf”主要用于设置数据库配置文件参数。gs_guc工具也可以用于设置数据库配置文件参数，同时发送信号量到数据库进程。配置“postgresql.conf”文件的语法为：
</p>
<p><span class="font_blue2">gs_guc set [-N
		NODE-NAME] [-I INSTANCE-NAME | -D DATADIR] -c "parameter = value"&nbsp;</span></p>
<p>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;其中各个参数的意义如表1-3-2所示。<br></p>
<p style="text-align:center;"></p>
<p style="text-align:center;">表1-3-2 gs_guc工具配置“postgresql.conf”文件的语法</p>
<table border="0" width="100%" cellpadding="0" cellspacing="0" class="insertTable">
	<thead>
		<tr>
			<td
				style="width: 81.1pt; border-right-width: 0.75pt; border-bottom-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; background-color: rgb(91, 155, 213);">
				<p
					style="margin-top: 0pt; margin-bottom: 0pt; text-indent: 22.1pt; text-align: center; font-size: 11pt;">
					<span style="font-family:微软雅黑; color:#ffffff">参数</span></p>
			</td>
			<td
				style="width: 102.6pt; border-right-width: 0.75pt; border-left-width: 0.75pt; border-bottom-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; background-color: rgb(91, 155, 213);">
				<p
					style="margin-top: 0pt; margin-bottom: 0pt; text-indent: 22.1pt; text-align: center; font-size: 11pt;">
					<span style="font-family:微软雅黑; color:#ffffff">意义</span></p>
			</td>
			<td
				style="width: 230.2pt; border-left-width: 0.75pt; border-bottom-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; background-color: rgb(91, 155, 213);">
				<p style="margin-top: 0pt; margin-bottom: 0pt; text-align: center; font-size: 11pt;"><span
						style="font-family:微软雅黑; color:#ffffff">备注</span></p>
			</td>
		</tr>
	</thead>
	<tbody>
		<tr>
			<td
				style="width: 81.1pt; border-top-width: 0.75pt; border-right-width: 0.75pt; border-bottom-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; background-color: rgb(221, 235, 247);">
				<p style="margin-top:0pt; margin-bottom:0pt; text-align:justify; font-size:10pt">set</p>
			</td>
			<td
				style="width: 102.6pt; border-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; background-color: rgb(221, 235, 247);">
				<p style="margin-top:0pt; margin-bottom:0pt; text-align:justify; font-size:10pt">表示只修改配置文件中的参数，不会立即生效。
				</p>
			</td>
			<td
				style="width: 230.2pt; border-top-width: 0.75pt; border-left-width: 0.75pt; border-bottom-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; vertical-align: top; background-color: rgb(221, 235, 247);">
				<p style="margin-top:0pt; margin-bottom:0pt; text-align:justify; font-size:10pt">&nbsp;</p>
			</td>
		</tr>
		<tr>
			<td
				style="width: 81.1pt; border-top-width: 0.75pt; border-right-width: 0.75pt; border-bottom-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; background-color: rgb(221, 235, 247);">
				<p style="margin-top:0pt; margin-bottom:0pt; text-align:justify; font-size:10pt">reload</p>
			</td>
			<td
				style="width: 102.6pt; border-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; background-color: rgb(221, 235, 247);">
				<p style="margin-top:0pt; margin-bottom:0pt; text-align:justify; font-size:10pt">
					表示修改配置文件中的参数，同时发送信号给数据库进程，使其重新加载配置文件生效。</p>
			</td>
			<td
				style="width: 230.2pt; border-top-width: 0.75pt; border-left-width: 0.75pt; border-bottom-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; vertical-align: top; background-color: rgb(221, 235, 247);">
				<p style="margin-top:0pt; margin-bottom:0pt; font-size:10pt">&nbsp;</p>
			</td>
		</tr>
		<tr>
			<td
				style="width: 81.1pt; border-top-width: 0.75pt; border-right-width: 0.75pt; border-bottom-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; background-color: rgb(221, 235, 247);">
				<p style="margin-top:0pt; margin-bottom:0pt; text-align:justify; font-size:10pt">-N</p>
			</td>
			<td
				style="width: 102.6pt; border-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; background-color: rgb(221, 235, 247);">
				<p style="margin-top:0pt; margin-bottom:0pt; text-align:justify; font-size:10pt">需要设置的主机名称。</p>
			</td>
			<td
				style="width: 230.2pt; border-top-width: 0.75pt; border-left-width: 0.75pt; border-bottom-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; background-color: rgb(221, 235, 247);">
				<p style="margin-top:0pt; margin-bottom:0pt; text-align:justify; font-size:10pt">
					取值范围可以为已有主机名称。当参数取值为all时，表示设置openGauss中所有的主机。</p>
			</td>
		</tr>
		<tr>
			<td
				style="width: 81.1pt; border-top-width: 0.75pt; border-right-width: 0.75pt; border-bottom-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; background-color: rgb(221, 235, 247);">
				<p style="margin-top:0pt; margin-bottom:0pt; text-align:justify; font-size:10pt">-I INSTANCE-NAME</p>
			</td>
			<td
				style="width: 102.6pt; border-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; background-color: rgb(221, 235, 247);">
				<p style="margin-top:0pt; margin-bottom:0pt; text-align:justify; font-size:10pt">需要设置的实例名称。</p>
			</td>
			<td
				style="width: 230.2pt; border-top-width: 0.75pt; border-left-width: 0.75pt; border-bottom-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; background-color: rgb(221, 235, 247);">
				<p style="margin-top:0pt; margin-bottom:0pt; text-align:justify; font-size:10pt">
					取值范围可以为已有实例名称。当参数取值为all时，表示设置主机中所有的实例。</p>
			</td>
		</tr>
		<tr>
			<td
				style="width: 81.1pt; border-top-width: 0.75pt; border-right-width: 0.75pt; border-bottom-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; background-color: rgb(221, 235, 247);">
				<p style="margin-top:0pt; margin-bottom:0pt; text-align:justify; font-size:10pt">-D DATADIR</p>
			</td>
			<td
				style="width: 102.6pt; border-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; background-color: rgb(221, 235, 247);">
				<p style="margin-top:0pt; margin-bottom:0pt; text-align:justify; font-size:10pt">需要执行命令的openGauss实例目录。
				</p>
			</td>
			<td
				style="width: 230.2pt; border-top-width: 0.75pt; border-left-width: 0.75pt; border-bottom-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; background-color: rgb(221, 235, 247);">
				<p style="margin-top:0pt; margin-bottom:0pt; text-align:justify; font-size:10pt">与“-I” 不能同时使用</p>
			</td>
		</tr>
		<tr>
			<td
				style="width: 81.1pt; border-top-width: 0.75pt; border-right-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; background-color: rgb(221, 235, 247);">
				<p style="margin-top:0pt; margin-bottom:0pt; text-align:justify; font-size:10pt">-c parameter=value</p>
			</td>
			<td
				style="width: 102.6pt; border-top-width: 0.75pt; border-right-width: 0.75pt; border-left-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; background-color: rgb(221, 235, 247);">
				<p style="margin-top:0pt; margin-bottom:0pt; text-align:justify; font-size:10pt">
					设定的openGauss配置参数的名称parameter和参数值value。</p>
			</td>
			<td
				style="width: 230.2pt; border-top-width: 0.75pt; border-left-width: 0.75pt; padding-right: 5.03pt; padding-left: 5.03pt; vertical-align: top; background-color: rgb(221, 235, 247);">
				<p style="margin-top:0pt; margin-bottom:0pt; text-align:justify; font-size:10pt">&nbsp;</p>
			</td>
		</tr>
	</tbody>
</table>
<p style="text-align: center;" id="video_p_FK4NARWH3C"><span class="td" id="video_td_span_FK4NARWH3C"><input
			id="check_FK4NARWH3C" type="checkbox" class="insertVideoCheck"><span class="videoTitlepc-new"
			id="video_title_span_FK4NARWH3C"
			style="background: url(https://dbook.hep.com.cn/admin/css/img/vedio_pic.png) no-repeat 5px 7px;background-size: 45px;">视频1-3-1
			认证配置</span><label for="check_FK4NARWH3C" class="check-in-new"
			style="background-image: url(&quot;https://dbook.hep.com.cn/admin/css/img/upICO.png&quot;); background-repeat: no-repeat; background-color: initial; background-size: 30px;"></label><label
			for="check_FK4NARWH3C" class="check-out-new"
			style="background-image: url(&quot;https://dbook.hep.com.cn/admin/css/img/downICO.png&quot;); background-repeat: no-repeat; background-color: initial; background-size: 30px;"></label><span
			class="element-new"><video res-type="video" class="insertVideo cres" id="FK4NARWH3C"
				src="https://dbook.hep.com.cn/api/v2/resource/preview?id=FK4NARWH3C" controls="" width="100%"
				poster="https://dbook.hep.com.cn/api/v2/resource/cover/preview?id=FK4NARWH3C"></video><br><span
				class="insertVideoTitle" id="video_title_FK4NARWH3C">视频1-3-1 认证配置</span></span></span></p>